<html><head><title>create procedure (SQL)</title><meta name="HandheldFriendly" content="True"></head><body>Creates a user defined stored procedure written in Transact SQL, or a wrapper for an Extended Stored Procedure.<br><br><b>create</b> {<b>proc</b> | <b>procedure</b>} [owner.]procedure[;number] [[(]{@parameter_name datatype [= default_value] [<b>output</b>]} <a href="w109049.html">(repeatable)</a>[)]] [<b>with</b> <b>recompile</b>] <b>as</b> {SQL_statements | <b>external</b> <b>name</b> dll}</body></html>